-- FireBoard 1.0.1 => 1.0.2

ALTER TABLE	`#__kunena_categories`		MODIFY `moderated` tinyint(4) NOT NULL default '1' AFTER `alert_admin`;
ALTER TABLE	`#__kunena_categories`		ADD `id_last_msg` int(10) NOT NULL DEFAULT '0' AFTER `description`;
ALTER TABLE	`#__kunena_categories`		ADD `numTopics` mediumint(8) NOT NULL DEFAULT '0' AFTER `id_last_msg`;
ALTER TABLE	`#__kunena_categories`		ADD `numPosts` mediumint(8) NOT NULL DEFAULT '0' AFTER `numTopics`;
ALTER TABLE	`#__kunena_categories`		ADD `time_last_msg` int(11) NULL AFTER `numPosts`;
ALTER TABLE	`#__kunena_categories`		ADD KEY `msg_id`(`id_last_msg`);
UPDATE		`#__kunena_categories`		SET `moderated` = '1';

ALTER TABLE	`#__kunena_messages`		ADD `modified_by` int(7) NULL AFTER `moved`;
ALTER TABLE	`#__kunena_messages`		ADD `modified_time` int(11) NULL AFTER `modified_by`;
ALTER TABLE	`#__kunena_messages`		ADD `modified_reason` tinytext NULL AFTER `modified_time`;

ALTER TABLE	`#__kunena_users`			ADD `personalText` tinytext NULL AFTER `uhits`;
ALTER TABLE	`#__kunena_users`			ADD `gender` tinyint(4) NOT NULL DEFAULT '0' AFTER `personalText`;
ALTER TABLE	`#__kunena_users`			ADD `birthdate` date NOT NULL DEFAULT '0001-01-01' AFTER `gender`;
ALTER TABLE	`#__kunena_users`			ADD `location` varchar(50) NULL AFTER `birthdate`;
ALTER TABLE	`#__kunena_users`			ADD `ICQ` varchar(50) NULL AFTER `location`;
ALTER TABLE	`#__kunena_users`			ADD `AIM` varchar(50) NULL AFTER `ICQ`;
ALTER TABLE	`#__kunena_users`			ADD `YIM` varchar(50) NULL AFTER `AIM`;
ALTER TABLE	`#__kunena_users`			ADD `MSN` varchar(50) NULL AFTER `YIM`;
ALTER TABLE	`#__kunena_users`			ADD `SKYPE` varchar(50) NULL AFTER `MSN`;
ALTER TABLE	`#__kunena_users`			ADD `hideEmail` tinyint(1) NOT NULL DEFAULT '1' AFTER `SKYPE`;
ALTER TABLE	`#__kunena_users`			ADD `showOnline` tinyint(1) NOT NULL DEFAULT '1' AFTER `hideEmail`;
ALTER TABLE	`#__kunena_users`			ADD `rank` tinyint(4) NOT NULL DEFAULT '0' AFTER `showOnline`;
ALTER TABLE	`#__kunena_users`			ADD `GTALK` varchar(50) NULL AFTER `rank`;
ALTER TABLE	`#__kunena_users`			ADD `websitename` varchar(50) NULL AFTER `GTALK`;
ALTER TABLE	`#__kunena_users`			ADD `websiteurl` varchar(50) NULL AFTER `websitename`;
